Data Load

Inspect

Bridge links used in query.

Sample of query data, each record details an activity_id, person_id, and link attributes. This table contains duplicate activity_ids if an activity uses more than 1 bridge link.

Toll rates used for single bridge usuage:

Analysis Observations

Activity Based Metrics

Number of unique bridge usages - calculated 2X ways, should be the same:

Number of activities that use at least one bridge:

Number of activities that use [1, 2, …N] bridge links:

Above table broken out by bridge usage link combinations.

Number of persons given activity count.

Number of persons given bridge usage count.

Bridges used given activity count.

Person Based Metrics

Distribution of activity start times.

Distribution of start time differences between subsequent trips.

Distribution of activity toll costs.

Distribution of total daily toll cost per person.

Distribution of average bridge toll cost per person.

## # A tibble: 3 x 3
## # Groups:   analysis [2]
##   analysis   thresh_4 count
##   <chr>      <lgl>    <int>
## 1 end_time   FALSE        6
## 2 end_time   TRUE         1
## 3 start_time FALSE        1

## # A tibble: 3 x 3
## # Groups:   analysis [2]
##   analysis   thresh_4 count
##   <chr>      <lgl>    <int>
## 1 end_time   FALSE        6
## 2 end_time   TRUE         1
## 3 start_time FALSE        1